using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class PT_AccountManagerBase
    {
        public PT_AccountManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity Insert(PT_AccountEntity obj)
        { 
            return (PT_AccountEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity Update(PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.Update(obj);             
        }
 
        public PT_AccountEntity Delete(PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.Delete(obj);             
        }
        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Address 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByAddress (string Address )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Address = Address;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"Address");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByCreatedBy (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByCreatedBy (string CreatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedBy = CreatedBy;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByCreatedDate (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByCreatedDate (DateTime CreatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedDate = CreatedDate;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDEALER_CODE (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DEALER_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DEALER_CODE 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDEALER_CODE (string DEALER_CODE )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DEALER_CODE = DEALER_CODE;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DEALER_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDisplayName (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DisplayName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DisplayName 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDisplayName (string DisplayName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DisplayName = DisplayName;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DisplayName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDOB (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DOB");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DOB 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByDOB (DateTime DOB )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DOB = DOB;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"DOB");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsActive (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsActive");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsActive 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsActive (bool IsActive )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsActive = IsActive;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsActive");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsDeleted (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsDeleted (bool IsDeleted )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsDeleted = IsDeleted;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsSystem (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsSystem");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsSystem 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByIsSystem (bool IsSystem )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsSystem = IsSystem;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"IsSystem");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByPassword (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"Password");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Password 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByPassword (string Password )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Password = Password;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"Password");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByRoleId (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"RoleId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RoleId 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByRoleId (int RoleId )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.RoleId = RoleId;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"RoleId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUpdatedBy (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUpdatedBy (string UpdatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedBy = UpdatedBy;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUpdatedDate (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedDate = UpdatedDate;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserCode (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserCode 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserCode (string UserCode )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserCode = UserCode;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserID (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserID 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserID (int UserID )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserID = UserID;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserName (PT_AccountEntity obj)
        { 
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UserName 
        /// </summary>
        /// <returns>PT_AccountEntity</returns>
        public PT_AccountEntity DeleteByUserName (string UserName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserName = UserName;  
            return (PT_AccountEntity)Adapter.DeleteByField(obj,"UserName");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public PT_AccountEntity Select(PT_AccountEntity obj)
        { 
            return (PT_AccountEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_AccountEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_AccountEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new PT_AccountEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new PT_AccountEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_AccountEntity> SelectAllLST()
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_AccountEntity()),new PT_AccountEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_AccountEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_AccountEntity(),option),new PT_AccountEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"Address");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Address",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByAddressLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByAddressLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Address",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (string Address )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Address = Address;  
            return Adapter.SelectByField(obj,"Address");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (string Address, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Address = Address;  
            return Adapter.SelectByField(obj,"Address",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByAddressLST (string Address )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Address = Address;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByAddressLST (string Address, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Address = Address;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByCreatedByLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByCreatedByLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedBy",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByCreatedByLST (string CreatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByCreatedByLST (string CreatedBy, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByCreatedDateLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByCreatedDateLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedDate",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByCreatedDateLST (DateTime CreatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByCreatedDateLST (DateTime CreatedDate, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDEALER_CODE (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"DEALER_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDEALER_CODE (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DEALER_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDEALER_CODELST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DEALER_CODE"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDEALER_CODELST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DEALER_CODE",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDEALER_CODE (string DEALER_CODE )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DEALER_CODE = DEALER_CODE;  
            return Adapter.SelectByField(obj,"DEALER_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDEALER_CODE (string DEALER_CODE, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DEALER_CODE = DEALER_CODE;  
            return Adapter.SelectByField(obj,"DEALER_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDEALER_CODELST (string DEALER_CODE )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DEALER_CODE = DEALER_CODE;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DEALER_CODE"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DEALER_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDEALER_CODELST (string DEALER_CODE, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DEALER_CODE = DEALER_CODE;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DEALER_CODE",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDisplayName (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"DisplayName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDisplayName (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DisplayName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDisplayNameLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DisplayName"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDisplayNameLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DisplayName",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDisplayName (string DisplayName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DisplayName = DisplayName;  
            return Adapter.SelectByField(obj,"DisplayName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDisplayName (string DisplayName, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DisplayName = DisplayName;  
            return Adapter.SelectByField(obj,"DisplayName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDisplayNameLST (string DisplayName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DisplayName = DisplayName;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DisplayName"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DisplayName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDisplayNameLST (string DisplayName, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DisplayName = DisplayName;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DisplayName",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDOB (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"DOB");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDOB (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DOB",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDOBLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DOB"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByDOBLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DOB",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDOB (DateTime DOB )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DOB = DOB;  
            return Adapter.SelectByField(obj,"DOB");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDOB (DateTime DOB, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DOB = DOB;  
            return Adapter.SelectByField(obj,"DOB",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDOBLST (DateTime DOB )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DOB = DOB;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DOB"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DOB duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByDOBLST (DateTime DOB, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.DOB = DOB;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DOB",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsActive (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsActive");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsActive (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsActive",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsActiveLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsActive"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsActiveLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsActive",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsActive (bool IsActive )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsActive = IsActive;  
            return Adapter.SelectByField(obj,"IsActive");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsActive (bool IsActive, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsActive = IsActive;  
            return Adapter.SelectByField(obj,"IsActive",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsActiveLST (bool IsActive )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsActive = IsActive;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsActive"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsActive duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsActiveLST (bool IsActive, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsActive = IsActive;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsActive",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsDeletedLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsDeletedLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsDeleted",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsDeletedLST (bool IsDeleted )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsDeletedLST (bool IsDeleted, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsSystem (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsSystem");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsSystem (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsSystem",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsSystemLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsSystem"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByIsSystemLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsSystem",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsSystem (bool IsSystem )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsSystem = IsSystem;  
            return Adapter.SelectByField(obj,"IsSystem");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsSystem (bool IsSystem, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsSystem = IsSystem;  
            return Adapter.SelectByField(obj,"IsSystem",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsSystemLST (bool IsSystem )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsSystem = IsSystem;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsSystem"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsSystem duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByIsSystemLST (bool IsSystem, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.IsSystem = IsSystem;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsSystem",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"Password");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Password",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByPasswordLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByPasswordLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Password",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (string Password )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Password = Password;  
            return Adapter.SelectByField(obj,"Password");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPassword (string Password, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Password = Password;  
            return Adapter.SelectByField(obj,"Password",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByPasswordLST (string Password )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Password = Password;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Password duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByPasswordLST (string Password, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.Password = Password;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Password",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRoleId (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"RoleId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRoleId (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RoleId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByRoleIdLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RoleId"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByRoleIdLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RoleId",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRoleId (int RoleId )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.RoleId = RoleId;  
            return Adapter.SelectByField(obj,"RoleId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRoleId (int RoleId, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.RoleId = RoleId;  
            return Adapter.SelectByField(obj,"RoleId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByRoleIdLST (int RoleId )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.RoleId = RoleId;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RoleId"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RoleId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByRoleIdLST (int RoleId, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.RoleId = RoleId;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RoleId",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUpdatedByLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUpdatedByLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedBy",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUpdatedByLST (string UpdatedBy )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUpdatedByLST (string UpdatedBy, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUpdatedDateLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUpdatedDateLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedDate",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUpdatedDateLST (DateTime UpdatedDate )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUpdatedDateLST (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserCode (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"UserCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserCode (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UserCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserCodeLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserCode"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserCodeLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UserCode",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserCode (string UserCode )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserCode = UserCode;  
            return Adapter.SelectByField(obj,"UserCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserCode (string UserCode, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserCode = UserCode;  
            return Adapter.SelectByField(obj,"UserCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserCodeLST (string UserCode )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserCode = UserCode;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserCode"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserCodeLST (string UserCode, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserCode = UserCode;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserCode",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserID (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"UserID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserID (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UserID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserIDLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserID"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserIDLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UserID",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserID (int UserID )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserID = UserID;  
            return Adapter.SelectByField(obj,"UserID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserID (int UserID, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserID = UserID;  
            return Adapter.SelectByField(obj,"UserID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserIDLST (int UserID )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserID = UserID;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserID"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserIDLST (int UserID, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserID = UserID;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserID",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (PT_AccountEntity obj)
        { 
            return Adapter.SelectByField(obj,"UserName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (PT_AccountEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UserName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserNameLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectByUserNameLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UserName",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (string UserName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserName = UserName;  
            return Adapter.SelectByField(obj,"UserName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUserName (string UserName, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserName = UserName;  
            return Adapter.SelectByField(obj,"UserName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserNameLST (string UserName )
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserName = UserName;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName"),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UserName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_AccountEntity> SelectByUserNameLST (string UserName, SelectOptions option)
        { 
            PT_AccountEntity obj = new PT_AccountEntity();
            obj.UserName = UserName;  
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UserName",option),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectWithConditionLST (PT_AccountEntity obj)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new PT_AccountEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_AccountEntity></returns>
        public List<PT_AccountEntity> SelectWithConditionLST (PT_AccountEntity obj,SelectOptions option)
        { 
            return  (List<PT_AccountEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new PT_AccountEntity());
        }

}
}
